Demo Dashboard — Q1 2023

KPI Overview — Q1 2023

📊 Key Insights

The restaurant generated $160,783 in total revenue across Q1 2023 (90 days), averaging $1,786/day and $29.96 per order.
With 5,366 orders and 12,217 items sold, customers ordered an average of 2.28 items per visit — indicating strong upsell and combo performance.
Italian cuisine led revenue at 31% share ($49,852), followed by Asian at 29.3% — together accounting for over 60% of total revenue.
March was the strongest month at $55,123, while February — despite the fewest days — delivered the highest average daily revenue at $1,832/day.

Revenue by Cuisine

Cuisine Revenue Share

Click on chart for details

Top 10 Items by Revenue

Click on chart for details

Menu Portfolio Distribution

Click on chart for details

Q2 2023 Forecast — Top 5 Items by Projected Order Volume

#	Item	Forecast Orders (Q2 2023)

Daily & Hourly Revenue — Q1 2023

📊 Key Insights

Dinner leads revenue at 54.2% ($87,161) vs lunch at 45.8% ($73,621), with a midday lunch peak at 12:00 ($21,874) and an early-evening shoulder at 17:00 ($18,039).
The mid-afternoon trough (15:00–16:00, ~$7,280 combined) represents an underutilised window — a targeted afternoon promotion could recover incremental revenue.
Evening trade (18:00–21:00) accounts for approximately $72,720 (45%) of daily revenue, making dinner service operationally critical despite lower volume.
Revenue drops sharply after 22:00 ($1,476) — late-night trade contributes less than 1% of daily revenue and may not justify full staffing.

Total Revenue by Hour of Day

Click on chart for details

Orders by Hour of Day

Click on chart for details

Avg Daily Revenue by Day of Week

Click on chart for details

Lunch vs Dinner — Q1 Total

Click on chart for details

Hourly Revenue Detail

Hour	Revenue ($)	Orders	Avg Order ($)

Revenue & Orders by Table — Q1 2023

📊 Key Insights

Table revenue is tightly clustered across all 15 tables, ranging from $10,147 (T15) to $11,852 (T14) — a spread of just $1,705.
T14 is the top-performing table at $11,852 revenue and 377 orders, suggesting it may benefit from superior placement, lighting, or server assignment.
T15 and T11 are the lowest performers by revenue — worth reviewing their positioning or service flow for improvement opportunities.
The narrow revenue spread across tables indicates consistent operational execution rather than table-driven variance, with performance driven more by time-of-day patterns.

Revenue by Table

Click on chart for details

Orders by Table

Click on chart for details

Table Performance Detail

Table	Revenue ($)	Orders	Avg Rev/Order ($)	Share of Total (%)

Menu Intelligence — Q1 2023

📊 Key Insights

Stars (high orders, high revenue) are led by Korean Beef Bowl ($13,022), Spaghetti & Meatballs ($12,438), and Hamburger ($9,557) — these 11 items are the revenue engine.
Cash Cows (high revenue, lower volume) like Pork Ramen and Meat Lasagna generate strong per-item value and should be protected on the menu despite modest order counts.
Workhorses — French Fries, Mac & Cheese, Chips & Salsa — are high-volume at low price points ($5–$7); they drive traffic and upsell opportunities but thin margins.
Review/Remove candidates (14 items) include Shrimp Scampi, Cheese Lasagna, and Hot Dog — low orders and low revenue; consolidating this list could reduce kitchen complexity and food waste.

Revenue by Menu Item (Top 15)

Click on chart for details

Portfolio Quadrant — Item Count

Click on chart for details

Menu Item Detail

Item	Cuisine	Price ($)	Orders	Revenue ($)	Quadrant

Trends — Q1 2023

📊 Key Insights

Weekly revenue held in a narrow $11,095–$13,643 band across all 13 weeks, indicating stable and predictable demand without significant volatility.
Week 5 ($13,643) was the peak week and Week 13 ($11,095) the trough — a difference of just 19%, pointing to a highly consistent operation.
March was the strongest month at $55,123, with Weeks 9–11 all above $12,467 — a late-Q1 momentum build that may reflect seasonal dining patterns.
The flat weekly trend suggests revenue growth will require deliberate intervention — new menu items, promotional events, or expanded capacity — rather than organic lift.

Monthly Revenue

Click on chart for details

Avg Daily Revenue by Month

Click on chart for details

Weekly Revenue

Click on chart for details

Lunch vs Dinner by Month

Click on chart for details

Monthly Summary

Month	Revenue ($)	Orders	Avg Daily Rev ($)	Days

Category Revenue by Month

Click on chart for details

February 2023 Deep-Dive

📊 Key Insights

Despite having the fewest days (28), February achieved the highest average daily revenue at $1,832 — outperforming January ($1,754) and March ($1,778).
February dinner revenue ($27,782) exceeded lunch ($23,518), mirroring the Q1 dinner-dominant split (54.2% dinner). No single daypart drove outperformance — it was broad-based across all hours.
February hourly revenue tracks closely to Q1 averages across most hours, with slight peaks at 12:00 and 13:00. The outperformance reflects broad-based consistency across all dayparts rather than a single standout hour.
The February premium is likely driven by Valentine's Day (14 Feb) dining demand — a high-value event to plan proactively with set menus and reservation management in Q1 2024.

February Hourly Revenue vs Q1 Average

Click on chart for details

February Lunch vs Dinner

Click on chart for details

February Daily Revenue vs Order Count

Click on chart for details

Day Segments — Q1 2023

📊 Key Insights

Monday is the strongest day at $2,017 avg daily revenue — 31% above Wednesday ($1,540), which is the weakest day of the week.
The mid-week trough (Wed–Thu) is a clear structural pattern: Wednesday ($1,540) and Thursday ($1,702) consistently underperform. Targeted mid-week promotions or events could close the gap.
Weekend performance is solid — Friday ($1,840) and Sunday ($1,802) rank near the top — but neither surpasses Monday, suggesting weekday loyal regulars are the primary revenue driver.
Saturday ($1,783) is mid-table, showing the restaurant's customer base skews toward regular weekday diners over weekend occasion visitors.

Avg Daily Revenue by Day of Week

Click on chart for details

Weekday vs Weekend — Avg Daily Revenue

Click on chart for details

Lunch vs Dinner by Day of Week

Click on chart for details

Q1 Meal Period Summary

Lunch Revenue (58%)

Dinner Revenue (42%)

Click on chart for details

Day of Week Detail

Day	Avg Daily Rev ($)	Avg Orders	vs Q1 Avg ($)

Monday Analysis — Best-Performing Day

Key Finding

Monday is the highest-revenue day of the week at $2,017 avg/day — 14% above the Q1 weekday average of $1,770. The driver is dinner volume (18:00–20:00), not elevated average spend. Monday dinner orders concentrate in the 6–8pm window, suggesting loyal regulars returning after the weekend.

Monday vs All-Day Average

Click on chart for details

Hourly Revenue — All Days of Week

Click on chart for details

Holiday Analysis — Q1 2023 (4 US Federal Holidays)

Recommendation

Holiday revenue averages $2,075/day — 17% above regular days. Holiday dinner per table is $75.70, the highest of any segment. Recommendation: Dinner-only operation on federal holidays (17:00–22:00) — consolidates revenue into peak hours, reduces labour costs, and capitalises on elevated per-table spend.

Holiday vs Regular Day — Revenue

Click on chart for details

Holiday Meal Period Revenue

Click on chart for details

Holiday Detail

Date	Holiday	Revenue ($)	Orders	vs Regular Avg